Skip Headers

Oracle® OLAP DML Reference 10g Release 2 (10.2) Part Number B14346-01 |
Home | Book List | Contents | Index | Master Index | Feedback

Previous | Next
| View PDF

# System Properties by Category

Within this document there are reference topics for system properties that you can use to specify behavior when:

- Aggregating or allocating data. See Table A-1, "System Properties Used When Aggregating or Allocating Data".

- Data cells are empty. See Table A-2, "System Properties Used When Working with NA Values".

- Creating multi-language programs and applications. See $DEFAULT_LANGUAGE.

OLAP has other special properties that are not as integral to the use of the OLAP DML. For example, properties are part of the object definitions for an analytic workspace in database standard form which is described inOracle OLAP Reference.

## System Properties Used When Aggregating Data

Table A-1, "System Properties Used When Aggregating or Allocating Data" lists system properties that relate to aggregation or allocation.

Table A-1 System Properties Used When Aggregating or Allocating Data

Property | Description
--- | ---
$AGGMAP | A property that specifies the default aggregation specification for a variable.
$AGGREGATE_FORCECALC | A property that specifies that any value that is not specified in a PRECOMPUTE clause of a RELATION (for aggregation) statement in the aggmap of a variable should be recalculated when an AGGREGATE function executes, even when there is a value stored in the desired cell.
$AGGREGATE_FORCEORDER | A property that specifies that the calculation must be performed in the order in which the RELATION (for aggregation) statements are listed in the aggmap.
$AGGREGATE_FROM | A property that specifies the name of an object from which to obtain detail data when aggregating data.
$AGGREGATE_FROMVAR | A property that specifies the objects from which to obtain detail data when aggregating data.
$ALLOCMAP | A property that specifies the default allocation specification for a variable.
$COUNTVAR | A property that specifies that Oracle OLAP counts the number of leaf nodes that contributed to an aggregate value when an AGGREGATE function executes.
$VARCACHE | A property that specifies whether Oracle OLAP stores or caches variable data that is the result of the execution of a AGGREGATE function or $NATRIGGER expression.

## System Properties that You Use with NA Values

Table A-2, "System Properties Used When Working with NA Values" lists system properties that you use when working with empty cells.

Table A-2 System Properties Used When Working with NA Values

Property | Description
--- | ---
$NATRIGGER | A property that specifies values to substitute for NA values that are in the object, but not in the session cache for the object (if any).
$STORETRIGGERVAL | A property that specifies that NA values in an object be permanently replaced by the values specified by the $NATRIGGER property.
$VARCACHE | A property that specifies whether Oracle OLAP stores or caches variable data that is the result of the execution of a AGGREGATE function or $NATRIGGER expression.